Ted,
Tom (Lane) told me a while ago that they changed timestamp and time
to be SQL92 compliant and they changed the way this now works.
Here is Tom's explanation from that time:
TIME is a reserved word now, or at least more reserved than it used to
be. You'll need to write 'now'::time or CAST('now' AS time). Sorry
about that, but SQL92 requires it...
Best regards,
Chris
At 19:03 -0500 01/26/2002, postgresql wrote:
>this works on postgresql 7.1.3.
>
>SELECT interval(('1/30/02 12:30 pm'::timestamp) - 'now');
>
>However, it is failing on the current beta. I have to change it to:
>
>SELECT ('1/30/02 12:30 pm'::timestamp) - 'now';
>
>Is this change to make PG more ANSI compliant? Was this
>documented? It took me a bit of hacking to find the correct syntax in
>7.2.
>
>Ted
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
--
Chris Ruprecht
Network grunt and bit pusher extraordinaíre
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com